home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Dr. Windows 3
/
dr win3.zip
/
dr win3
/
GRAPHICS
/
TABPRW20.ZIP
/
TABPRO.DOC
< prev
next >
Wrap
Text File
|
1993-08-22
|
26KB
|
681 lines
Tab123 Professional, copyright 1991-93 Mountain Software
-=TabPro=-
AutoCAD Spreadsheet Interface
Version 2.0
July 30, 1993
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
Autodesk Registered Application Developer
Novell Professional Developer
Jerry Workman, P.E.
1579 Nottingham Road
Charleston, WV 25314
CIS 70717,3564
Internet 70717.3564@compuserve.com
Orders: 1-800-2424-PsL
Tech Support: 304-346-9585
FAX 304-744-1785
Table of Contents
I. U s i n g T a b P r o . . . . . . . . . . . . . . . . 1
Purpose . . . . . . . . . . . . . . . . . . . . . . . . 1
Installation . . . . . . . . . . . . . . . . . . . . . . 1
Running TabPro . . . . . . . . . . . . . . . . . . . . . 2
Release 12 Proteus (Windowed) interface . . . . . . . . 2
Release 11 command line interface . . . . . . . . . . . 4
Limits . . . . . . . . . . . . . . . . . . . . . . . . . 5
Suggestions . . . . . . . . . . . . . . . . . . . . . . 6
II. A d d e n d u m . . . . . . . . . . . . . . . . . . . . 7
Liability . . . . . . . . . . . . . . . . . . . . . . . 7
Author . . . . . . . . . . . . . . . . . . . . . . . . . 7
III. L i c e n s e . . . . . . . . . . . . . . . . . . . . . 7
Registration Information . . . . . . . . . . . . . . . . 8
Definition of Shareware . . . . . . . . . . . . . . . . 8
Disclaimer - Agreement . . . . . . . . . . . . . . . . . 9
Trademark . . . . . . . . . . . . . . . . . . . . . . . 10
IV. I n d e x . . . . . . . . . . . . . . . . . . . . . . . 11
TabPro version 2.0 Documentation page 1
I. U s i n g T a b P r o
============================
Purpose
-------
TabPro is a utility for AutoCAD release 11 or release 12 that
imports Lotus 123, Symphony, and Excel spreadsheet files into an
AutoCAD drawing as a table of text entities, and if desired, a
cell grid to enclose the table. TabPro runs from within the
AutoCAD drawing editor and will read Lotus WKS, WK1, and WRK
files as well as Excel XLS files directly.
The program reads not only the data from the spreadsheet file,
but also calculated formula values, formatting information,
column widths, cell formats, and cell alignment. TabPro is an ADS
application for AutoCAD 386 and AutoCAD for Windows. TabPro works
on any IBM PC compatible computer capable of running AutoCAD
release 12.
Installation
------------
Install the TabPro files from the distribution diskette archive
file to any subdirectory accessible by AutoCAD. You can have
AutoCAD automatically load TabPro by adding the full path in the
ACAD.ADS file (usually found in the SUPPORT directory).
You may also use the APPLOAD utility to add TABPRO.EXP to the
APPLOAD menu.
TabPro version 2.0 Documentation page 2
Running TabPro
--------------
First load the ADS program:
Command: (XLOAD"TABPRO")
You may also add TABPRO to your ACAD.ADS file to load TabPro
automatically each time that you start AutoCAD. Or you can use
the AutoCAD command ACADAPP to load Tabpro.
Then execute...
Command: TabPro
Release 12 Proteus (Windowed) interface:
----------------------------------------
TabPro Dialogue
Filename (required)
Enter the filename of a Lotus 123 or Excel file, or select the
File Button to invoke the file dialogue box. TabPro supports
Lotus WRK, WKS, WK1, and WK3 file formats as well as all versions
of Excel XLS files.
Range
Enter the range to import or select the Range button to pick a
Names range from the worksheet file. The range must be in the
form <sheet>:<column><row>..<sheet>:<column><row>. The <sheet>
specifier is only necessary if you wish to extract data from a
sheet other that sheet "A" in a Lotus 123 WK3 file.
Examples:
A1..E25 column A row 1 to column E row 25
B:C11..B:G34 sheet B column A row 1 to column E row 25
* all cells (a blank range also selects all)
MY_RANGE named range
Text Layer
Select the AutoCAD layer on which to place text entities or
select the Layers button to invoke the AutoCAD "DDLMODES"
dialogue box where you can create a new layer or modify layer
settings. If you make a different layer current while in the
DDLMODES dialogue, that layer then becomes the text layer.
TabPro version 2.0 Documentation page 3
Text Style
Select the AutoCAD text style to use for text entities or select
the Styles button to create a new text style. The default text
style is the current AutoCAD style in effect when you first start
TabPro.
Text Height
Enter the text height in drawing units. The default value is
taken from the current style if the style contains a text height,
or the AutoCAD system variable TEXTSIZE. The entire table is
scaled based on this value.
Row Scale Factor
The row scale factor defines the spacing between rows in terms of
the text height. This factor is multiplied by the text height to
determine the row spacing. A value of 1.0 is will allow adjacent
text rows to just touch bottom to top. The default value is 2.00.
Column Offset Factor
The column offset factor defines the horizontal spacing (in
characters) between the start or end of the text and the cell
boundary. The default value is 1.00.
Grid
Select the grid button to select grid linetype and border line
weight. You can also adjust the density of linetypes using
AutoCAD's LTSCALE system variable.
Grid Layer
Select the AutoCAD layer on which to place grid line entities, or
select the Layers button to invoke the AutoCAD "DDLMODES"
dialogue box where you can create a new layer or modify layer
settings.
Style Creation Dialogue
Select a text style to create either from the pick list or the